﻿CREATE PROCEDURE [dbo].[usp_OptionFactor_Tbl_Ins] 
	@Product nvarchar(50),
	@ConstID int,
	@UsageTypeID int,
	@GenSailTypeID int,
	@GenYarnID int,
	@TPI nvarchar(50),
	@OptionID int,
	@OptionPriceFactor float
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	INSERT INTO OptionFactor_Tbl (Product, ConstructionID, UsageTypeID, GenSailTypeID, GenericYarnID, TierPriceIndicator, OptionID, OptionPriceFactor) values (@Product, @ConstID, @UsageTypeID, @GenSailTypeID, @GenYarnID, @TPI
, @OptionID, @OptionPriceFactor)
END